============================================================================== Simba QuickBooks ODBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba QuickBooks ODBC Connector 1.7.8, as well as the version history. 1.7.8 ======================================================================== Released 2024-06-26 Enhancements & New Features * [MPH-16276] Updated Ubuntu support The connector now supports Ubuntu 24.04 version. For a list of supported platform versions, see the Installation and Configuration Guide. * [MPH-16341] Updated FIPS support You can now enable FIPS support by downloading a separate FIPS package available for assistance. For more information, see the Installation and Configuration Guide. * Update on database schemas No new database schema are added, modified and decommissioned. Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application. * In some cases, if you query data while the EncryptSwapFile property is set to 1, the connector might return a corrupted result set. When this issue occurs, the returned result set is corrupted, but the original data in the data store is not affected. As a potential workaround, do either of the following: - Disable swap file creation by setting the MemoryManagerStrategy property to 1. However, be aware that while this setting prevents the connector from returning corrupted result sets, it may also cause some SQL operations on non-SQL data to return out-of-memory errors. - If your query does not involve sensitive data, set the EncryptSwapFile property to 0 before running the query. However, be aware that when swap file encryption is disabled, any data that the connector caches in order to support the query is written in plain text. For more information about the swap file and memory manager features, see the Installation and Configuration Guide. * In some cases, during the first time that you use the connector to retrieve an access token, the connector might terminate unexpectedly. This issue is known to occur on rare occasions. As a workaround, try to retrieve the access token again. * If you use Internet Explorer as your default web browser, the connector cannot retrieve access tokens. The OAuth 2.0 authentication flow that the connector goes through to retrieve access tokens is not supported on Internet Explorer. As a workaround, set a different web browser as your default before attempting to retrieve an access token. * On Windows, the connector cannot use the EncAccessToken setting if the Auth_AccessToken string value exists in the registry key for the DSN. If the Auth_AccessToken string value exists in the DSN registry key, the connector cannot authenticate the connection using the EncAccessToken setting. This issue occurs even if there is no value data specified in Auth_AccessToken. As a workaround, delete the Auth_AccessToken string value from your DSN registry key if you want to use the EncAccessToken setting for authentication. * Reusing a prepared statement handle may cause a memory leak. If a prepared statement handle is used more than once, a memory leak may occur. * Entries in the Company_Currency table cannot be made inactive. When you set the Active field to "false" for an entry in the Company_Currency table, the entry remains active and continues to be returned in SELECT query results. Workflow Changes ============================================================= The following changes may disrupt workflows from earlier versions. 1.7.8 ------------------------------------------------------------------------ * [MPH-16295] Removed support for earlier versions of platform Beginning with this release, the connector no longer supports the following versions of platform: - Windows Server 2012r2 - macOS 10.15 - CentOS 7 - Debian 9 and 10 - Red Hat® Enterprise Linux® (RHEL) 7 For a list of supported platform versions, see the Installation and Configuration Guide. 1.7.6 ------------------------------------------------------------------------ * Removed support for Visual Studio 2015 Beginning with this release, support for Visual C++ Redistributable for Visual Studio 2015 has been removed. For supported versions, see the Installation and Configuration Guide. 1.7.2 ------------------------------------------------------------------------ * Updated UseProxy default value The default value for UseProxy is now Disabled (0). Previously, the default value was Enabled (1). For more information, see the Installation and Configuration Guide. 1.6.40 ----------------------------------------------------------------------- * Removed support for OS platforms Beginning with this release, the connector no longer supports the following OS platforms: - Windows 7 SP1 - Windows Server 2008 R2 For a list of supported OS versions, see the Installation and Configuration Guide. * Removed support for Visual C++ Redistributable for Visual Studio 2013 Beginning with this release, the connector no longer supports this version of the dependency and requires Visual C++ Redistributable for Visual Studio 2015 instead. For information about the supported Visual C++ Redistributable for Visual Studio versions, see the Installation and Configuration Guide. 1.6.0 ------------------------------------------------------------------------ * Updated configuration requirements for OAuth 2.0 token retrieval Beginning with this release, the driver requires additional configuration in order to retrieve access tokens and refresh tokens for authentication. Make sure to update any connections that are authenticated through token retrieval. For more information, see the Installation and Configuration Guide. 1.5.5 ------------------------------------------------------------------------ * Updated Auth_Type value Beginning with this release, when you connect using a connection string, you must set the Auth_Type property to "OAuth 2.0" instead of "OAuth_2.0". Existing connection strings that specify Auth_Type=OAuth_2.0 may no longer work as expected. To resolve this issue, update the Auth_Type value in your connection strings. 1.5.4 ------------------------------------------------------------------------ * Updated requirements for the QuickBooksODBC.did file on Windows Beginning with this release, the driver requires the QuickBooksODBC.did file to be included in the \lib subfolder in the driver installation directory on Windows, regardless of the type of installation being used. Otherwise, the driver does not work as expected. - If your Windows Registry specifies the QuickBooksODBCPlugin_sb32.dll or QuickBooksODBCPlugin_sb64.dll file as the driver library file, then you must copy the QuickBooksODBC.did file into the \lib subfolder. - Or, if your Windows Registry specifies the RDFODBC_sb32.dll or RDFODBC_sb32.dll file as the driver library file, then you must rename the QuickBooksODBC.did file into "RDFODBC.did", and then copy that file into the \lib subfolder. When upgrading to this version of the driver, make sure that the QuickBooksODBC.did file has been named and copied as described above. 1.5.2 ------------------------------------------------------------------------ * Minimum TLS Version Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2. To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide. Version History ============================================================== 1.7.7 ------------------------------------------------------------------------ Released 2024-04-11 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.6.2 (previously 2.6.0) - libcURL 8.7.1 (previously 8.6.0) 1.7.6 ------------------------------------------------------------------------ Released 2024-03-21 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.6.0 (previously 2.5.0) - libcURL v8.6.0 (previously 8.4.0) - OpenSSL v3.0.13 (previously 3.0.11) - pcre 10.42 (previously 8.45) - Poco 1.12.5 (previously 1.12.4) - Zlib 1.3.1 (previously 1.2.13) * Updated security The following compiler and linker flags have been used to improve security checks in the connector: - /CETCOMPAT - /Qspectre * Updated Visual Studio support The connector now supports Windows Visual Studio 2022. For supported versions, see the Installation and Configuration Guide. * Updated Windows support The connector now supports Windows 11 and Windows Server versions 2016, 2019, and 2022. For supported Windows versions, see the Installation and Configuration Guide. 1.7.4 ------------------------------------------------------------------------ Released 2023-10-23 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - LibCurl 8.4.0 (previously 8.1.2) - OpenSSL 3.0.11 (previously 3.0.9) - Pcre 8.45 (previously 8.37) * Updated security The following compiler and linker flags have been used to improve security checks in the connector: - /guard:cf - /SDL - ZH:SHA_256 * Updated compiler The connector now uses macOS 11 ARM Xcode 13.2. For this current release, the connector is built using both the new and old (macOS 10_15 Xcode 11_3) compiler versions. 1.7.3 ------------------------------------------------------------------------ Released 2023-07-03 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - LibCurl 8.1.2 (previously 7.88.1) - OpenSSL 3.0.9 (previously 3.0.8) 1.7.2 ------------------------------------------------------------------------ Released 2023-05-17 Enhancements & New Features * Internal connector improvements The connector has been updated with minor internal improvements. 1.7.1 ------------------------------------------------------------------------ Released 2023-04-03 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.5.0 (previously 2.4.6) - ICU 71.1.x (previously 58.3.x) - LibCurl 7.88.1 (previously 7.84) - OpenSSL 3.0.8 (previously 1.1.1s) - Poco 1.12.4 (previously 1.9.0) - ZLib 1.2.13 (previously 1.2.11) * UseProxy support The connector can now enable or disable the connection through the proxy server. To do this, select the Use Proxy checkbox (set the UseProxy connection property to 1). For more information, see the Installation and Configuration Guide. * Additional stored procedures The connector now includes additional stored procedures. For more information, see the Reference Guide. ==============================================================================